﻿CREATE TYPE [dbo].[udtCashSaleDetails] AS TABLE (
    [DetailsID]      INT             NOT NULL,
    [CashSaleID]     INT             NULL,
    [ProductID]      INT             NOT NULL,
    [Quantity]       DECIMAL (11, 2) NOT NULL,
    [Price]          DECIMAL (11, 2) NOT NULL,
    [RabattPercent1] DECIMAL (11, 2) NOT NULL,
    [RabattPercent2] DECIMAL (11, 2) NOT NULL,
    [RabattFix]      DECIMAL (11, 2) NOT NULL,
    [TaxCode]        TINYINT         NOT NULL,
    [TaxRate]        DECIMAL (11, 2) NOT NULL);


GO
GRANT CONTROL
    ON TYPE::[dbo].[udtCashSaleDetails] TO PUBLIC;


GO
GRANT REFERENCES
    ON TYPE::[dbo].[udtCashSaleDetails] TO PUBLIC;


GO
GRANT TAKE OWNERSHIP
    ON TYPE::[dbo].[udtCashSaleDetails] TO PUBLIC;

